
Use Tunga;

GO
--Insert Booking Table Detail
Alter PROC insertBookingTableDetail
	@[bookingtableid] int,
	@[tableid] int,
	@[money] float,
	@[quantity] int
AS
INSERT INTO  BookingTableDetail([bookingtableid],[tableid],[money],[quantity]) 
VALUES (@[bookingtableid],@[tablesid],@[money],@[quantity])	
GO
--Get All Booking Table Detail By Booking Table ID
Alter PROC getAllOrderFoodDetailByOrderFoodID
	@[bookingtableid] int
AS
SELECT	[Table].[id], BookingTableDetail.[quantity], BookingTableDetail.[tableid], BookingTableDetail.[money]
FROM	BookingTableDetail INNER JOIN Food ON BookingTableDetail.[tableid] = [Table].[id]
WHERE	BookingTableDetail.[bookingtableid] = @[bookingtableid]
GO



